Sales by Size Sheet
16
1. Right click on Hourly Avg Orders worksheet and select Duplicate. Rename the new sheet as Sales By Size.
2. Remove all the values from Marks shelf.
3. Drag and drop Pizza Size to Columns and Total Price to Rows.
4. Drag and drop Measure Values to Rows Shelf. Right click on Measure Values and select Edit Filter. From the list select:
Avg Price MoM%
Orders MoM%
Sales MoM%
Unselect all other values. Click Ok.
5. Right click Measure Values and select Dual axis.
6. Under Marks, select Chart type = Bar for SUM(Quantity) and Chart type = Line for Measure Values.
7. Click on Color under Marks and select Edit colors. Assign the colors for values as below:
Avg Price MoM% - #009867
Orders MoM% - #747474
Sales MoM% - #6b3b00
Total Price - #dfbb43
8. Right click on Y axis label and select Edit axis. Under Range, select Fixed.
Fixed Start = 0, Fixed End = 600,000
Under Axis Titles, leave the title blank.
9. Right click on X axis label and select Edit axis. Under Range, select Fixed.
Fixed Start = -0.167, Fixed End = 0.420
Under Axis Titles, leave the title blank.
10.
Click anywhere on the chart (on empty space), select Format. Click
Lines, under Rows, Grid lines = None, Row Divider Pane = None. Under
Columns, Column Divider, Pane = None.
10. Drag and drop Date Filter to Filters shelf and select only True option.
11. Click on Tooltip under marks and enter the following:
Pizza Size: <Pizza Size>
Total Sales:<SUM(Total Price)>
Sales MoM:<AGG(Sales MoM %)>
Avg Orders:<AGG(Avg Orders By Day)>
Orders MoM:<AGG(Orders MoM %)>
Avg Price:<AGG(Avg Pizza Price)>
Avg Price MoM:<AGG(Avg Price MoM %)>
Font = Tableau Book, Size = 8, Bold, Alignment = Left
12. Right click on Title, select Edit Title, add the title Sales by Size.
Follow the Gif files below for step by step instructions:
How to create Dual axis chart in Tableau